/*
{
"状态":1,
"名称":"获取-权限角色信息",
"作者":"马学兵",
"创建时间":"2018-08-20",
"功能":"获取-权限角色信息",
"log": [
	{"date":"06-01" , "dev" :"hzhh" , "content" : ""}
]
}
*/

declare @power_key int 
set @power_key='{power_key}'

SELECT y_role.role_key,y_role.role_id,y_role.role_name FROM dbo.y_role_power INNER JOIN dbo.y_role ON y_role.role_key = y_role_power.role_key
WHERE power_key=@power_key